Indexes on local temp tables cannot be created , rebuilt , or dropped online 无法为本地临时表联机创建、重新生成或删除索引。
On is not valid for indexed views , nonclustered indexes or indexes on local temp tables On对于索引视图、非聚集索引或本地临时表的索引无效。
Indexes , including indexes on global temp tables , can be created online with the following exceptions 可以联机创建包括全局临时表上的索引在内的索引,但下列索引例外:
Indexes , including indexes on global temp tables , can be rebuilt online with the following exceptions 索引(包括全局临时表中的索引)可以联机重新生成,但以下索引除外:
Applications that acquire a large amount of user data inside temp tables or temp variables can cause space use problems in 在临时表或临时变量中获取大量用户数据的应用程序可能会导致
You can use an approach similar to polling queries for monitoring the space used by temp tables and temp variables 可以使用一种类似于轮询查询的方法来监视临时表和临时变量使用的空间。
The second method can be used to identify the specific query , temp table , or table variable that is consuming the disk space , but more data must be collected to obtain the answer 第二种方法可用于标识占用磁盘空间的特定查询、临时表或表变量,但要获得答案必须收集更多数据。